/*
 Navicat Premium Data Transfer

 Source Server         : ali-mysql
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : 39.107.92.215:3306
 Source Schema         : mall-sys

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 08/11/2021 15:29:55
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_category_brand
-- ----------------------------
DROP TABLE IF EXISTS `tb_category_brand`;
CREATE TABLE `tb_category_brand` (
  `category_id` bigint NOT NULL COMMENT '商品类目id',
  `brand_id` bigint NOT NULL COMMENT '品牌id',
  PRIMARY KEY (`category_id`,`brand_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='商品分类和品牌的中间表，两者是多对多关系';

-- ----------------------------
-- Records of tb_category_brand
-- ----------------------------
BEGIN;
INSERT INTO `tb_category_brand` VALUES (3, 325407);
INSERT INTO `tb_category_brand` VALUES (3, 325409);
INSERT INTO `tb_category_brand` VALUES (57, 325404);
INSERT INTO `tb_category_brand` VALUES (57, 325405);
INSERT INTO `tb_category_brand` VALUES (57, 325406);
INSERT INTO `tb_category_brand` VALUES (61, 325404);
INSERT INTO `tb_category_brand` VALUES (61, 325405);
INSERT INTO `tb_category_brand` VALUES (61, 325406);
INSERT INTO `tb_category_brand` VALUES (76, 1528);
INSERT INTO `tb_category_brand` VALUES (76, 1912);
INSERT INTO `tb_category_brand` VALUES (76, 2032);
INSERT INTO `tb_category_brand` VALUES (76, 2505);
INSERT INTO `tb_category_brand` VALUES (76, 3177);
INSERT INTO `tb_category_brand` VALUES (76, 3539);
INSERT INTO `tb_category_brand` VALUES (76, 3941);
INSERT INTO `tb_category_brand` VALUES (76, 4986);
INSERT INTO `tb_category_brand` VALUES (76, 6522);
INSERT INTO `tb_category_brand` VALUES (76, 6742);
INSERT INTO `tb_category_brand` VALUES (76, 7174);
INSERT INTO `tb_category_brand` VALUES (76, 7203);
INSERT INTO `tb_category_brand` VALUES (76, 7420);
INSERT INTO `tb_category_brand` VALUES (76, 7817);
INSERT INTO `tb_category_brand` VALUES (76, 7888);
INSERT INTO `tb_category_brand` VALUES (76, 8214);
INSERT INTO `tb_category_brand` VALUES (76, 8551);
INSERT INTO `tb_category_brand` VALUES (76, 8557);
INSERT INTO `tb_category_brand` VALUES (76, 8740);
INSERT INTO `tb_category_brand` VALUES (76, 9420);
INSERT INTO `tb_category_brand` VALUES (76, 9637);
INSERT INTO `tb_category_brand` VALUES (76, 10317);
INSERT INTO `tb_category_brand` VALUES (76, 10640);
INSERT INTO `tb_category_brand` VALUES (76, 11516);
INSERT INTO `tb_category_brand` VALUES (76, 12286);
INSERT INTO `tb_category_brand` VALUES (76, 12669);
INSERT INTO `tb_category_brand` VALUES (76, 13066);
INSERT INTO `tb_category_brand` VALUES (76, 13539);
INSERT INTO `tb_category_brand` VALUES (76, 14026);
INSERT INTO `tb_category_brand` VALUES (76, 14478);
INSERT INTO `tb_category_brand` VALUES (76, 15127);
INSERT INTO `tb_category_brand` VALUES (76, 15539);
INSERT INTO `tb_category_brand` VALUES (76, 16506);
INSERT INTO `tb_category_brand` VALUES (76, 16538);
INSERT INTO `tb_category_brand` VALUES (76, 16975);
INSERT INTO `tb_category_brand` VALUES (76, 17193);
INSERT INTO `tb_category_brand` VALUES (76, 17424);
INSERT INTO `tb_category_brand` VALUES (76, 17440);
INSERT INTO `tb_category_brand` VALUES (76, 18078);
INSERT INTO `tb_category_brand` VALUES (76, 18362);
INSERT INTO `tb_category_brand` VALUES (76, 18374);
INSERT INTO `tb_category_brand` VALUES (76, 20130);
INSERT INTO `tb_category_brand` VALUES (76, 20710);
INSERT INTO `tb_category_brand` VALUES (76, 21011);
INSERT INTO `tb_category_brand` VALUES (76, 21360);
INSERT INTO `tb_category_brand` VALUES (76, 21553);
INSERT INTO `tb_category_brand` VALUES (76, 22261);
INSERT INTO `tb_category_brand` VALUES (76, 22575);
INSERT INTO `tb_category_brand` VALUES (76, 23049);
INSERT INTO `tb_category_brand` VALUES (76, 23130);
INSERT INTO `tb_category_brand` VALUES (76, 25376);
INSERT INTO `tb_category_brand` VALUES (76, 25591);
INSERT INTO `tb_category_brand` VALUES (76, 27094);
INSERT INTO `tb_category_brand` VALUES (76, 27306);
INSERT INTO `tb_category_brand` VALUES (76, 32315);
INSERT INTO `tb_category_brand` VALUES (76, 36404);
INSERT INTO `tb_category_brand` VALUES (76, 36652);
INSERT INTO `tb_category_brand` VALUES (76, 36654);
INSERT INTO `tb_category_brand` VALUES (76, 36657);
INSERT INTO `tb_category_brand` VALUES (76, 38125);
INSERT INTO `tb_category_brand` VALUES (76, 38126);
INSERT INTO `tb_category_brand` VALUES (76, 38605);
INSERT INTO `tb_category_brand` VALUES (76, 43644);
INSERT INTO `tb_category_brand` VALUES (76, 45227);
INSERT INTO `tb_category_brand` VALUES (76, 45693);
INSERT INTO `tb_category_brand` VALUES (76, 45757);
INSERT INTO `tb_category_brand` VALUES (76, 49144);
INSERT INTO `tb_category_brand` VALUES (76, 50450);
INSERT INTO `tb_category_brand` VALUES (76, 51040);
INSERT INTO `tb_category_brand` VALUES (76, 52302);
INSERT INTO `tb_category_brand` VALUES (76, 53317);
INSERT INTO `tb_category_brand` VALUES (76, 54347);
INSERT INTO `tb_category_brand` VALUES (76, 55524);
INSERT INTO `tb_category_brand` VALUES (76, 56411);
INSERT INTO `tb_category_brand` VALUES (76, 59110);
INSERT INTO `tb_category_brand` VALUES (76, 60106);
INSERT INTO `tb_category_brand` VALUES (76, 63032);
INSERT INTO `tb_category_brand` VALUES (76, 63833);
INSERT INTO `tb_category_brand` VALUES (76, 68927);
INSERT INTO `tb_category_brand` VALUES (76, 89010);
INSERT INTO `tb_category_brand` VALUES (76, 91515);
INSERT INTO `tb_category_brand` VALUES (76, 102501);
INSERT INTO `tb_category_brand` VALUES (76, 104490);
INSERT INTO `tb_category_brand` VALUES (76, 109150);
INSERT INTO `tb_category_brand` VALUES (76, 110303);
INSERT INTO `tb_category_brand` VALUES (76, 113718);
INSERT INTO `tb_category_brand` VALUES (76, 114119);
INSERT INTO `tb_category_brand` VALUES (76, 123856);
INSERT INTO `tb_category_brand` VALUES (76, 128080);
INSERT INTO `tb_category_brand` VALUES (76, 129098);
INSERT INTO `tb_category_brand` VALUES (76, 130455);
INSERT INTO `tb_category_brand` VALUES (76, 131546);
INSERT INTO `tb_category_brand` VALUES (76, 133747);
INSERT INTO `tb_category_brand` VALUES (76, 134922);
INSERT INTO `tb_category_brand` VALUES (76, 135967);
INSERT INTO `tb_category_brand` VALUES (76, 149070);
INSERT INTO `tb_category_brand` VALUES (76, 151370);
INSERT INTO `tb_category_brand` VALUES (76, 151844);
INSERT INTO `tb_category_brand` VALUES (76, 155608);
INSERT INTO `tb_category_brand` VALUES (76, 159313);
INSERT INTO `tb_category_brand` VALUES (76, 174275);
INSERT INTO `tb_category_brand` VALUES (76, 178969);
INSERT INTO `tb_category_brand` VALUES (76, 179105);
INSERT INTO `tb_category_brand` VALUES (76, 179528);
INSERT INTO `tb_category_brand` VALUES (76, 179624);
INSERT INTO `tb_category_brand` VALUES (76, 180213);
INSERT INTO `tb_category_brand` VALUES (76, 194213);
INSERT INTO `tb_category_brand` VALUES (76, 196065);
INSERT INTO `tb_category_brand` VALUES (76, 197126);
INSERT INTO `tb_category_brand` VALUES (76, 203084);
INSERT INTO `tb_category_brand` VALUES (76, 204089);
INSERT INTO `tb_category_brand` VALUES (76, 205278);
INSERT INTO `tb_category_brand` VALUES (76, 209178);
INSERT INTO `tb_category_brand` VALUES (76, 214915);
INSERT INTO `tb_category_brand` VALUES (76, 219484);
INSERT INTO `tb_category_brand` VALUES (76, 221149);
INSERT INTO `tb_category_brand` VALUES (76, 222294);
INSERT INTO `tb_category_brand` VALUES (76, 223023);
INSERT INTO `tb_category_brand` VALUES (76, 223199);
INSERT INTO `tb_category_brand` VALUES (76, 223316);
INSERT INTO `tb_category_brand` VALUES (76, 225085);
INSERT INTO `tb_category_brand` VALUES (76, 228280);
INSERT INTO `tb_category_brand` VALUES (76, 233984);
INSERT INTO `tb_category_brand` VALUES (76, 234746);
INSERT INTO `tb_category_brand` VALUES (76, 238798);
INSERT INTO `tb_category_brand` VALUES (76, 240112);
INSERT INTO `tb_category_brand` VALUES (76, 246053);
INSERT INTO `tb_category_brand` VALUES (76, 247149);
INSERT INTO `tb_category_brand` VALUES (76, 247652);
INSERT INTO `tb_category_brand` VALUES (76, 248132);
INSERT INTO `tb_category_brand` VALUES (76, 249404);
INSERT INTO `tb_category_brand` VALUES (76, 253520);
INSERT INTO `tb_category_brand` VALUES (76, 261196);
INSERT INTO `tb_category_brand` VALUES (76, 261480);
INSERT INTO `tb_category_brand` VALUES (76, 262180);
INSERT INTO `tb_category_brand` VALUES (76, 262334);
INSERT INTO `tb_category_brand` VALUES (76, 264451);
INSERT INTO `tb_category_brand` VALUES (76, 265247);
INSERT INTO `tb_category_brand` VALUES (76, 267981);
INSERT INTO `tb_category_brand` VALUES (76, 271696);
INSERT INTO `tb_category_brand` VALUES (76, 276102);
INSERT INTO `tb_category_brand` VALUES (76, 276381);
INSERT INTO `tb_category_brand` VALUES (76, 276780);
INSERT INTO `tb_category_brand` VALUES (76, 278268);
INSERT INTO `tb_category_brand` VALUES (76, 278755);
INSERT INTO `tb_category_brand` VALUES (76, 279173);
INSERT INTO `tb_category_brand` VALUES (76, 280120);
INSERT INTO `tb_category_brand` VALUES (76, 280152);
INSERT INTO `tb_category_brand` VALUES (76, 284571);
INSERT INTO `tb_category_brand` VALUES (76, 285331);
INSERT INTO `tb_category_brand` VALUES (76, 286273);
INSERT INTO `tb_category_brand` VALUES (76, 287292);
INSERT INTO `tb_category_brand` VALUES (76, 290104);
INSERT INTO `tb_category_brand` VALUES (76, 290682);
INSERT INTO `tb_category_brand` VALUES (76, 302250);
INSERT INTO `tb_category_brand` VALUES (76, 304654);
INSERT INTO `tb_category_brand` VALUES (76, 314866);
INSERT INTO `tb_category_brand` VALUES (76, 316578);
INSERT INTO `tb_category_brand` VALUES (76, 316596);
INSERT INTO `tb_category_brand` VALUES (76, 316618);
INSERT INTO `tb_category_brand` VALUES (76, 325397);
INSERT INTO `tb_category_brand` VALUES (76, 325408);
INSERT INTO `tb_category_brand` VALUES (84, 18374);
INSERT INTO `tb_category_brand` VALUES (86, 18374);
INSERT INTO `tb_category_brand` VALUES (90, 325398);
INSERT INTO `tb_category_brand` VALUES (90, 325399);
INSERT INTO `tb_category_brand` VALUES (94, 18374);
INSERT INTO `tb_category_brand` VALUES (105, 6742);
INSERT INTO `tb_category_brand` VALUES (105, 7817);
INSERT INTO `tb_category_brand` VALUES (105, 7888);
INSERT INTO `tb_category_brand` VALUES (105, 16538);
INSERT INTO `tb_category_brand` VALUES (105, 18374);
INSERT INTO `tb_category_brand` VALUES (105, 23130);
INSERT INTO `tb_category_brand` VALUES (106, 7817);
INSERT INTO `tb_category_brand` VALUES (107, 7817);
INSERT INTO `tb_category_brand` VALUES (108, 7817);
INSERT INTO `tb_category_brand` VALUES (117, 18374);
INSERT INTO `tb_category_brand` VALUES (128, 18374);
INSERT INTO `tb_category_brand` VALUES (167, 6742);
INSERT INTO `tb_category_brand` VALUES (170, 6742);
INSERT INTO `tb_category_brand` VALUES (324, 18374);
INSERT INTO `tb_category_brand` VALUES (326, 18374);
INSERT INTO `tb_category_brand` VALUES (327, 18374);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
